﻿namespace Triad.Framework
{
    using System;
    using System.Data;

    public partial class exComboBox : Triad.Web.UI.Page
    {

        protected override void OnInit(EventArgs e)
        {
            IncludeJQuery = true;
            base.OnInit(e);
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            FillCB2();


        }
        private void FillCB2()
        {
            Triad.DAL.TriadDataReader objReader = new Triad.DAL.TriadDataReader();
            
            DataTable dt = Triad.DAL.NorthWind.NorthWindDBSProcs.Create().GetCustOrders(10634);
            tfcb2.DataSource = dt;
            tfcb2.DataValueField = "UnitPrice";
            tfcb2.DataTextField = "ProductName";
            tfcb2.DataBind();
            tfcb2.Items.Insert(0, "Select Site");
            tfcb2.Items[0].Value = "";
        }
        
    }
}
